Dataset info
| Number of variables | 22 |
|---|---|
| Number of observations | 15762 |
| Missing cells | 0 (0.0%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 2.6 MiB |
| Average record size in memory | 176.0 B |
Variables types
| Numeric | 19 |
|---|---|
| Categorical | 2 |
| Boolean | 1 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 0 |
| Unsupported | 0 |
Warnings
date has a high cardinality: 369 distinct values | Warning |
sqft_basement has a high cardinality: 283 distinct values | Warning |
view has 14241 (90.4%) zeros | Zeros |
yr_renovated has 15111 (95.9%) zeros | Zeros |
bathrooms
Numeric
| Distinct count | 27 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.120796853 |
|---|---|
| Minimum | 0.5 |
| Maximum | 8 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.5 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1.75 |
| Median | 2.25 |
| Q3 | 2.5 |
| 95-th percentile | 3.5 |
| Maximum | 8 |
| Range | 7.5 |
| Interquartile range | 0.75 |
Descriptive statistics
| Standard deviation | 0.7667716477 |
|---|---|
| Coef of variation | 0.3615488426 |
| Kurtosis | 1.343529285 |
| Mean | 2.120796853 |
| MAD | 0.6122442832 |
| Skewness | 0.5179102509 |
| Sum | 33428 |
| Variance | 0.5879387597 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=27)
Histogram with variable size bins (bins=[0.5 0.625 0.875 1.125 1.375 ... 3.625 4.125 4.625 5.625 8. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 2.5 | 4004 | 25.4% | |
| 1 | 2761 | 17.5% | |
| 1.75 | 2226 | 14.1% | |
| 2.25 | 1487 | 9.4% | |
| 2 | 1395 | 8.9% | |
| 1.5 | 1060 | 6.7% | |
| 2.75 | 853 | 5.4% | |
| 3 | 543 | 3.4% | |
| 3.5 | 543 | 3.4% | |
| 3.25 | 428 | 2.7% | |
| Other values (17) | 462 | 2.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.5 | 3 | < 0.1% | |
| 0.75 | 50 | 0.3% | |
| 1 | 2761 | 17.5% | |
| 1.25 | 6 | < 0.1% | |
| 1.5 | 1060 | 6.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8 | 2 | < 0.1% | |
| 7.75 | 1 | < 0.1% | |
| 7.5 | 1 | < 0.1% | |
| 6.75 | 1 | < 0.1% | |
| 6 | 5 | < 0.1% |
bedrooms
Numeric
| Distinct count | 12 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.378949372 |
|---|---|
| Minimum | 1 |
| Maximum | 33 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| Median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 33 |
| Range | 32 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.9353010799 |
|---|---|
| Coef of variation | 0.2768023361 |
| Kurtosis | 65.29214176 |
| Mean | 3.378949372 |
| MAD | 0.7353872581 |
| Skewness | 2.5301133 |
| Sum | 53259 |
| Variance | 0.87478811 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=12)
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 5.5 6.5 7.5 10.5 33. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 3 | 7120 | 45.2% | |
| 4 | 5079 | 32.2% | |
| 2 | 2003 | 12.7% | |
| 5 | 1183 | 7.5% | |
| 6 | 192 | 1.2% | |
| 1 | 141 | 0.9% | |
| 7 | 23 | 0.1% | |
| 8 | 10 | 0.1% | |
| 9 | 6 | < 0.1% | |
| 10 | 3 | < 0.1% | |
| Other values (2) | 2 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 141 | 0.9% | |
| 2 | 2003 | 12.7% | |
| 3 | 7120 | 45.2% | |
| 4 | 5079 | 32.2% | |
| 5 | 1183 | 7.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 33 | 1 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 10 | 3 | < 0.1% | |
| 9 | 6 | < 0.1% | |
| 8 | 10 | 0.1% |
condition
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.410861566 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 3 |
| Median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.6519608965 |
|---|---|
| Coef of variation | 0.1911425849 |
| Kurtosis | 0.4942516587 |
| Mean | 3.410861566 |
| MAD | 0.562117155 |
| Skewness | 1.0385374 |
| Sum | 53762 |
| Variance | 0.4250530106 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=5)
| Value | Count | Frequency (%) | |
| 3 | 10221 | 64.8% | |
| 4 | 4137 | 26.2% | |
| 5 | 1254 | 8.0% | |
| 2 | 131 | 0.8% | |
| 1 | 19 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 19 | 0.1% | |
| 2 | 131 | 0.8% | |
| 3 | 10221 | 64.8% | |
| 4 | 4137 | 26.2% | |
| 5 | 1254 | 8.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5 | 1254 | 8.0% | |
| 4 | 4137 | 26.2% | |
| 3 | 10221 | 64.8% | |
| 2 | 131 | 0.8% | |
| 1 | 19 | 0.1% |
date
Categorical
| Distinct count | 369 |
|---|---|
| Unique (%) | 2.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 6/25/2014 | 103 |
|---|---|
| 6/23/2014 | 102 |
| 7/14/2014 | 93 |
| Other values (366) |
| Value | Count | Frequency (%) | |
| 6/25/2014 | 103 | 0.7% | |
| 6/23/2014 | 102 | 0.6% | |
| 7/14/2014 | 93 | 0.6% | |
| 7/8/2014 | 93 | 0.6% | |
| 4/28/2015 | 93 | 0.6% | |
| 10/28/2014 | 92 | 0.6% | |
| 5/20/2014 | 89 | 0.6% | |
| 8/20/2014 | 89 | 0.6% | |
| 4/27/2015 | 89 | 0.6% | |
| 4/22/2015 | 88 | 0.6% | |
| Other values (359) | 14831 | 94.1% |
| Max length | 10 |
|---|---|
| Mean length | 8.924375079 |
| Min length | 8 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
df_index
Numeric
| Distinct count | 15762 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 10782.56941 |
|---|---|
| Minimum | 1 |
| Maximum | 21596 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1064.05 |
| Q1 | 5398.25 |
| Median | 10782.5 |
| Q3 | 16150.75 |
| 95-th percentile | 20476.95 |
| Maximum | 21596 |
| Range | 21595 |
| Interquartile range | 10752.5 |
Descriptive statistics
| Standard deviation | 6218.086579 |
|---|---|
| Coef of variation | 0.5766794855 |
| Kurtosis | -1.194688287 |
| Mean | 10782.56941 |
| MAD | 5381.085712 |
| Skewness | -0.001794292219 |
| Sum | 169954859 |
| Variance | 38664600.7 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[1.0000e+00 2.1596e+04], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 6806 | 1 | < 0.1% | |
| 14994 | 1 | < 0.1% | |
| 8849 | 1 | < 0.1% | |
| 21135 | 1 | < 0.1% | |
| 19084 | 1 | < 0.1% | |
| 4743 | 1 | < 0.1% | |
| 645 | 1 | < 0.1% | |
| 2692 | 1 | < 0.1% | |
| 14978 | 1 | < 0.1% | |
| Other values (15752) | 15752 | 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 21596 | 1 | < 0.1% | |
| 21594 | 1 | < 0.1% | |
| 21593 | 1 | < 0.1% | |
| 21592 | 1 | < 0.1% | |
| 21591 | 1 | < 0.1% |
floors
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.495146555 |
|---|---|
| Minimum | 1 |
| Maximum | 3.5 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1.5 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 3.5 |
| Range | 2.5 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.5393516866 |
|---|---|
| Coef of variation | 0.360734996 |
| Kurtosis | -0.5043981528 |
| Mean | 1.495146555 |
| MAD | 0.4886124551 |
| Skewness | 0.6056036105 |
| Sum | 23566.5 |
| Variance | 0.2909002418 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) | |
| 1 | 7777 | 49.3% | |
| 2 | 6049 | 38.4% | |
| 1.5 | 1374 | 8.7% | |
| 3 | 439 | 2.8% | |
| 2.5 | 117 | 0.7% | |
| 3.5 | 6 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 7777 | 49.3% | |
| 1.5 | 1374 | 8.7% | |
| 2 | 6049 | 38.4% | |
| 2.5 | 117 | 0.7% | |
| 3 | 439 | 2.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3.5 | 6 | < 0.1% | |
| 3 | 439 | 2.8% | |
| 2.5 | 117 | 0.7% | |
| 2 | 6049 | 38.4% | |
| 1.5 | 1374 | 8.7% |
grade
Numeric
| Distinct count | 11 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 7.663748255 |
|---|---|
| Minimum | 3 |
| Maximum | 13 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 7 |
| Median | 7 |
| Q3 | 8 |
| 95-th percentile | 10 |
| Maximum | 13 |
| Range | 10 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.172238401 |
|---|---|
| Coef of variation | 0.1529588867 |
| Kurtosis | 1.151892098 |
| Mean | 7.663748255 |
| MAD | 0.9280617225 |
| Skewness | 0.8035754559 |
| Sum | 120796 |
| Variance | 1.374142869 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=11)
Histogram with variable size bins (bins=[ 3. 4.5 5.5 6.5 7.5 ... 9.5 10.5 11.5 12.5 13. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 7 | 6539 | 41.5% | |
| 8 | 4438 | 28.2% | |
| 9 | 1920 | 12.2% | |
| 6 | 1482 | 9.4% | |
| 10 | 832 | 5.3% | |
| 11 | 290 | 1.8% | |
| 5 | 167 | 1.1% | |
| 12 | 66 | 0.4% | |
| 4 | 16 | 0.1% | |
| 13 | 11 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 3 | 1 | < 0.1% | |
| 4 | 16 | 0.1% | |
| 5 | 167 | 1.1% | |
| 6 | 1482 | 9.4% | |
| 7 | 6539 | 41.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 13 | 11 | 0.1% | |
| 12 | 66 | 0.4% | |
| 11 | 290 | 1.8% | |
| 10 | 832 | 5.3% | |
| 9 | 1920 | 12.2% |
id
Numeric
| Distinct count | 15676 |
|---|---|
| Unique (%) | 99.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 4593363852 |
|---|---|
| Minimum | 1000102 |
| Maximum | 9895000040 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1000102 |
|---|---|
| 5-th percentile | 522049616.6 |
| Q1 | 2125159330 |
| Median | 3905081210 |
| Q3 | 7334501432 |
| 95-th percentile | 9297301504 |
| Maximum | 9895000040 |
| Range | 9893999938 |
| Interquartile range | 5209342102 |
Descriptive statistics
| Standard deviation | 2876078445 |
|---|---|
| Coef of variation | 0.6261377363 |
| Kurtosis | -1.265290014 |
| Mean | 4593363852 |
| MAD | 2544792076 |
| Skewness | 0.2348705489 |
| Sum | 7.240060104e+13 |
| Variance | 8.27182722e+18 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[1.00010200e+06 1.15007750e+07 1.15155350e+07 1.60002060e+07 1.60004900e+07 ... 9.83420024e+09 9.83420142e+09 9.83930042e+09 9.83930111e+09 9.89500004e+09], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 6632900574 | 2 | < 0.1% | |
| 9353300600 | 2 | < 0.1% | |
| 5101402435 | 2 | < 0.1% | |
| 722039087 | 2 | < 0.1% | |
| 1523049207 | 2 | < 0.1% | |
| 9407110710 | 2 | < 0.1% | |
| 3271300955 | 2 | < 0.1% | |
| 9834200885 | 2 | < 0.1% | |
| 1139600270 | 2 | < 0.1% | |
| 6300000226 | 2 | < 0.1% | |
| Other values (15666) | 15742 | 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1000102 | 1 | < 0.1% | |
| 1200021 | 1 | < 0.1% | |
| 2800031 | 1 | < 0.1% | |
| 3600057 | 1 | < 0.1% | |
| 5200087 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9895000040 | 1 | < 0.1% | |
| 9842300485 | 1 | < 0.1% | |
| 9842300095 | 1 | < 0.1% | |
| 9842300036 | 1 | < 0.1% | |
| 9839301165 | 1 | < 0.1% |
lat
Numeric
| Distinct count | 4747 |
|---|---|
| Unique (%) | 30.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 47.55917675 |
|---|---|
| Minimum | 47.1559 |
| Maximum | 47.7776 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 47.1559 |
|---|---|
| 5-th percentile | 47.3099 |
| Q1 | 47.4692 |
| Median | 47.571 |
| Q3 | 47.6774 |
| 95-th percentile | 47.7492 |
| Maximum | 47.7776 |
| Range | 0.6217 |
| Interquartile range | 0.2082 |
Descriptive statistics
| Standard deviation | 0.1386290362 |
|---|---|
| Coef of variation | 0.002914874597 |
| Kurtosis | -0.6862934938 |
| Mean | 47.55917675 |
| MAD | 0.1148537102 |
| Skewness | -0.4785235348 |
| Sum | 749627.7439 |
| Variance | 0.01921800966 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[47.1559 47.18955 47.2161 47.2571 47.26495 ... 47.66805 47.69935 47.74675 47.75955 47.7776 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 47.6846 | 14 | 0.1% | |
| 47.6955 | 14 | 0.1% | |
| 47.6624 | 13 | 0.1% | |
| 47.6711 | 13 | 0.1% | |
| 47.6647 | 13 | 0.1% | |
| 47.5322 | 13 | 0.1% | |
| 47.6914 | 12 | 0.1% | |
| 47.6368 | 12 | 0.1% | |
| 47.5491 | 12 | 0.1% | |
| 47.6684 | 12 | 0.1% | |
| Other values (4737) | 15634 | 99.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 47.1559 | 1 | < 0.1% | |
| 47.1593 | 1 | < 0.1% | |
| 47.1647 | 1 | < 0.1% | |
| 47.1764 | 1 | < 0.1% | |
| 47.1775 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 47.7776 | 3 | < 0.1% | |
| 47.7775 | 2 | < 0.1% | |
| 47.7772 | 3 | < 0.1% | |
| 47.7771 | 1 | < 0.1% | |
| 47.777 | 1 | < 0.1% |
long
Numeric
| Distinct count | 728 |
|---|---|
| Unique (%) | 4.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | -122.2135195 |
|---|---|
| Minimum | -122.519 |
| Maximum | -121.315 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | -122.519 |
|---|---|
| 5-th percentile | -122.387 |
| Q1 | -122.328 |
| Median | -122.229 |
| Q3 | -122.124 |
| 95-th percentile | -121.979 |
| Maximum | -121.315 |
| Range | 1.204 |
| Interquartile range | 0.204 |
Descriptive statistics
| Standard deviation | 0.1407064419 |
|---|---|
| Coef of variation | -0.001151316503 |
| Kurtosis | 0.9879899801 |
| Mean | -122.2135195 |
| MAD | 0.1150718315 |
| Skewness | 0.8718665429 |
| Sum | -1926329.495 |
| Variance | 0.0197983028 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[-122.519 -122.466 -122.4155 -122.4105 -122.4005 ... -121.7685 -121.7335 -121.6945 -121.411 -121.315 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| -122.29 | 86 | 0.5% | |
| -122.365 | 78 | 0.5% | |
| -122.3 | 77 | 0.5% | |
| -122.288 | 76 | 0.5% | |
| -122.363 | 74 | 0.5% | |
| -122.357 | 73 | 0.5% | |
| -122.172 | 72 | 0.5% | |
| -122.362 | 71 | 0.5% | |
| -122.306 | 71 | 0.5% | |
| -122.304 | 71 | 0.5% | |
| Other values (718) | 15013 | 95.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -122.519 | 1 | < 0.1% | |
| -122.515 | 1 | < 0.1% | |
| -122.514 | 1 | < 0.1% | |
| -122.512 | 1 | < 0.1% | |
| -122.511 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| -121.315 | 1 | < 0.1% | |
| -121.321 | 1 | < 0.1% | |
| -121.325 | 1 | < 0.1% | |
| -121.352 | 2 | < 0.1% | |
| -121.359 | 1 | < 0.1% |
price
Numeric
| Distinct count | 3034 |
|---|---|
| Unique (%) | 19.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 541317.1757 |
|---|---|
| Minimum | 82000 |
| Maximum | 7700000 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 82000 |
|---|---|
| 5-th percentile | 212000 |
| Q1 | 321000 |
| Median | 450000 |
| Q3 | 644875 |
| 95-th percentile | 1160000 |
| Maximum | 7700000 |
| Range | 7618000 |
| Interquartile range | 323875 |
Descriptive statistics
| Standard deviation | 372225.8387 |
|---|---|
| Coef of variation | 0.6876298322 |
| Kurtosis | 38.08318766 |
| Mean | 541317.1757 |
| MAD | 234706.1635 |
| Skewness | 4.226727018 |
| Sum | 8532241324 |
| Variance | 1.38552075e+11 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 82000. 109250. 149950. 150500. 159537.5 ... 1705000. 2005000. 2590000. 3825000. 7700000. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 350000 | 129 | 0.8% | |
| 450000 | 120 | 0.8% | |
| 500000 | 115 | 0.7% | |
| 550000 | 113 | 0.7% | |
| 425000 | 111 | 0.7% | |
| 525000 | 104 | 0.7% | |
| 400000 | 100 | 0.6% | |
| 325000 | 98 | 0.6% | |
| 375000 | 97 | 0.6% | |
| 300000 | 96 | 0.6% | |
| Other values (3024) | 14679 | 93.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 82000 | 1 | < 0.1% | |
| 82500 | 1 | < 0.1% | |
| 83000 | 1 | < 0.1% | |
| 84000 | 1 | < 0.1% | |
| 85000 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7700000 | 1 | < 0.1% | |
| 7060000 | 1 | < 0.1% | |
| 6890000 | 1 | < 0.1% | |
| 5350000 | 1 | < 0.1% | |
| 5110000 | 1 | < 0.1% |
sqft_above
Numeric
| Distinct count | 835 |
|---|---|
| Unique (%) | 5.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1792.775473 |
|---|---|
| Minimum | 370 |
| Maximum | 9410 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 370 |
|---|---|
| 5-th percentile | 850 |
| Q1 | 1200 |
| Median | 1570 |
| Q3 | 2220 |
| 95-th percentile | 3400 |
| Maximum | 9410 |
| Range | 9040 |
| Interquartile range | 1020 |
Descriptive statistics
| Standard deviation | 828.4035021 |
|---|---|
| Coef of variation | 0.4620787794 |
| Kurtosis | 3.437242825 |
| Mean | 1792.775473 |
| MAD | 641.3179445 |
| Skewness | 1.441481453 |
| Sum | 28257727 |
| Variance | 686252.3623 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 370. 555. 665. 695. 762.5 ... 4505. 4775. 5485. 6680. 9410. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 1300 | 152 | 1.0% | |
| 1200 | 144 | 0.9% | |
| 1010 | 143 | 0.9% | |
| 1220 | 137 | 0.9% | |
| 1060 | 134 | 0.9% | |
| 1180 | 131 | 0.8% | |
| 1140 | 131 | 0.8% | |
| 1320 | 130 | 0.8% | |
| 1250 | 129 | 0.8% | |
| 1080 | 129 | 0.8% | |
| Other values (825) | 14402 | 91.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 370 | 1 | < 0.1% | |
| 380 | 1 | < 0.1% | |
| 390 | 1 | < 0.1% | |
| 410 | 1 | < 0.1% | |
| 420 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9410 | 1 | < 0.1% | |
| 8860 | 1 | < 0.1% | |
| 8570 | 1 | < 0.1% | |
| 7880 | 1 | < 0.1% | |
| 7850 | 1 | < 0.1% |
sqft_basement
Categorical
| Distinct count | 283 |
|---|---|
| Unique (%) | 1.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0.0 | |
|---|---|
| ? | 333 |
| 600.0 | 155 |
| Other values (280) |
| Value | Count | Frequency (%) | |
| 0.0 | 9362 | 59.4% | |
| ? | 333 | 2.1% | |
| 600.0 | 155 | 1.0% | |
| 500.0 | 151 | 1.0% | |
| 700.0 | 148 | 0.9% | |
| 400.0 | 144 | 0.9% | |
| 800.0 | 139 | 0.9% | |
| 900.0 | 101 | 0.6% | |
| 1000.0 | 99 | 0.6% | |
| 300.0 | 98 | 0.6% | |
| Other values (273) | 5032 | 31.9% |
| Max length | 6 |
|---|---|
| Mean length | 3.815505646 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
sqft_living
Numeric
| Distinct count | 912 |
|---|---|
| Unique (%) | 5.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2084.512372 |
|---|---|
| Minimum | 370 |
| Maximum | 13540 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 370 |
|---|---|
| 5-th percentile | 940 |
| Q1 | 1430 |
| Median | 1920 |
| Q3 | 2550 |
| 95-th percentile | 3760 |
| Maximum | 13540 |
| Range | 13170 |
| Interquartile range | 1120 |
Descriptive statistics
| Standard deviation | 918.6176865 |
|---|---|
| Coef of variation | 0.4406870878 |
| Kurtosis | 5.747514663 |
| Mean | 2084.512372 |
| MAD | 697.627182 |
| Skewness | 1.500560911 |
| Sum | 32856084 |
| Variance | 843858.4539 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 370. 505. 655. 695. 824. ... 4505. 4876.5 5900. 8005. 13540. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 1820 | 102 | 0.6% | |
| 1440 | 100 | 0.6% | |
| 1400 | 97 | 0.6% | |
| 1300 | 95 | 0.6% | |
| 1320 | 94 | 0.6% | |
| 1720 | 91 | 0.6% | |
| 1540 | 91 | 0.6% | |
| 1510 | 89 | 0.6% | |
| 1800 | 89 | 0.6% | |
| 1830 | 88 | 0.6% | |
| Other values (902) | 14826 | 94.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 370 | 1 | < 0.1% | |
| 380 | 1 | < 0.1% | |
| 390 | 1 | < 0.1% | |
| 410 | 1 | < 0.1% | |
| 420 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 13540 | 1 | < 0.1% | |
| 12050 | 1 | < 0.1% | |
| 10040 | 1 | < 0.1% | |
| 9890 | 1 | < 0.1% | |
| 9640 | 1 | < 0.1% |
sqft_living15
Numeric
| Distinct count | 694 |
|---|---|
| Unique (%) | 4.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1990.219579 |
|---|---|
| Minimum | 399 |
| Maximum | 6210 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 399 |
|---|---|
| 5-th percentile | 1140 |
| Q1 | 1490 |
| Median | 1846 |
| Q3 | 2370 |
| 95-th percentile | 3300 |
| Maximum | 6210 |
| Range | 5811 |
| Interquartile range | 880 |
Descriptive statistics
| Standard deviation | 684.1424953 |
|---|---|
| Coef of variation | 0.3437522686 |
| Kurtosis | 1.631805886 |
| Mean | 1990.219579 |
| MAD | 535.3537565 |
| Skewness | 1.102719855 |
| Sum | 31369841 |
| Variance | 468050.9538 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 399. 680. 815. 956. 994. ... 3935. 4115. 4765. 5095. 6210.], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 1560 | 150 | 1.0% | |
| 1540 | 146 | 0.9% | |
| 1440 | 142 | 0.9% | |
| 1800 | 130 | 0.8% | |
| 1500 | 125 | 0.8% | |
| 1580 | 125 | 0.8% | |
| 1460 | 123 | 0.8% | |
| 1760 | 123 | 0.8% | |
| 1640 | 122 | 0.8% | |
| 1680 | 120 | 0.8% | |
| Other values (684) | 14456 | 91.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 399 | 1 | < 0.1% | |
| 460 | 1 | < 0.1% | |
| 620 | 2 | < 0.1% | |
| 670 | 1 | < 0.1% | |
| 690 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 6210 | 1 | < 0.1% | |
| 6110 | 1 | < 0.1% | |
| 5790 | 5 | < 0.1% | |
| 5600 | 1 | < 0.1% | |
| 5500 | 1 | < 0.1% |
sqft_lot
Numeric
| Distinct count | 7927 |
|---|---|
| Unique (%) | 50.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 15280.82141 |
|---|---|
| Minimum | 520 |
| Maximum | 1651359 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 520 |
|---|---|
| 5-th percentile | 1827 |
| Q1 | 5048.5 |
| Median | 7602 |
| Q3 | 10720 |
| 95-th percentile | 43709.5 |
| Maximum | 1651359 |
| Range | 1650839 |
| Interquartile range | 5671.5 |
Descriptive statistics
| Standard deviation | 41822.88332 |
|---|---|
| Coef of variation | 2.736952564 |
| Kurtosis | 309.6894817 |
| Mean | 15280.82141 |
| MAD | 14107.33686 |
| Skewness | 13.40978595 |
| Sum | 240856307 |
| Variance | 1749153569 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[5.200000e+02 6.785000e+02 8.635000e+02 1.147500e+03 1.351500e+03 ... 2.178670e+05 2.254330e+05 2.862680e+05 4.408265e+05 1.651359e+06], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 5000 | 277 | 1.8% | |
| 6000 | 204 | 1.3% | |
| 4000 | 177 | 1.1% | |
| 7200 | 151 | 1.0% | |
| 4800 | 89 | 0.6% | |
| 4500 | 88 | 0.6% | |
| 8400 | 82 | 0.5% | |
| 7500 | 80 | 0.5% | |
| 9600 | 79 | 0.5% | |
| 3600 | 75 | 0.5% | |
| Other values (7917) | 14460 | 91.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 520 | 1 | < 0.1% | |
| 572 | 1 | < 0.1% | |
| 609 | 1 | < 0.1% | |
| 649 | 2 | < 0.1% | |
| 676 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1651359 | 1 | < 0.1% | |
| 1164794 | 1 | < 0.1% | |
| 1024068 | 1 | < 0.1% | |
| 982998 | 1 | < 0.1% | |
| 982278 | 1 | < 0.1% |
sqft_lot15
Numeric
| Distinct count | 7126 |
|---|---|
| Unique (%) | 45.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 12900.41556 |
|---|---|
| Minimum | 659 |
| Maximum | 871200 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 659 |
|---|---|
| 5-th percentile | 2044.2 |
| Q1 | 5100 |
| Median | 7620 |
| Q3 | 10107.5 |
| 95-th percentile | 37563 |
| Maximum | 871200 |
| Range | 870541 |
| Interquartile range | 5007.5 |
Descriptive statistics
| Standard deviation | 27977.23006 |
|---|---|
| Coef of variation | 2.168707662 |
| Kurtosis | 169.8269317 |
| Mean | 12900.41556 |
| MAD | 10315.5775 |
| Skewness | 10.00386182 |
| Sum | 203336350 |
| Variance | 782725401.8 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[6.590000e+02 9.145000e+02 1.057000e+03 1.169500e+03 1.428000e+03 ... 2.177995e+05 2.180110e+05 2.245520e+05 4.364705e+05 8.712000e+05], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 5000 | 313 | 2.0% | |
| 4000 | 262 | 1.7% | |
| 6000 | 201 | 1.3% | |
| 7200 | 153 | 1.0% | |
| 7500 | 102 | 0.6% | |
| 4800 | 99 | 0.6% | |
| 4500 | 89 | 0.6% | |
| 3600 | 86 | 0.5% | |
| 5100 | 84 | 0.5% | |
| 8400 | 78 | 0.5% | |
| Other values (7116) | 14295 | 90.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 659 | 1 | < 0.1% | |
| 660 | 1 | < 0.1% | |
| 750 | 4 | < 0.1% | |
| 755 | 1 | < 0.1% | |
| 757 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 871200 | 1 | < 0.1% | |
| 858132 | 1 | < 0.1% | |
| 560617 | 1 | < 0.1% | |
| 438213 | 1 | < 0.1% | |
| 434728 | 1 | < 0.1% |
view
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.2299835046 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros (%) | 90.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.7613244113 |
|---|---|
| Coef of variation | 3.31034355 |
| Kurtosis | 11.32979091 |
| Mean | 0.2299835046 |
| MAD | 0.4155811559 |
| Skewness | 3.45271416 |
| Sum | 3625 |
| Variance | 0.5796148592 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=5)
| Value | Count | Frequency (%) | |
| 0 | 14241 | 90.4% | |
| 2 | 688 | 4.4% | |
| 3 | 348 | 2.2% | |
| 1 | 245 | 1.6% | |
| 4 | 240 | 1.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 14241 | 90.4% | |
| 1 | 245 | 1.6% | |
| 2 | 688 | 4.4% | |
| 3 | 348 | 2.2% | |
| 4 | 240 | 1.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4 | 240 | 1.5% | |
| 3 | 348 | 2.2% | |
| 2 | 688 | 4.4% | |
| 1 | 245 | 1.6% | |
| 0 | 14241 | 90.4% |
waterfront
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 120 |
| Value | Count | Frequency (%) | |
| 0 | 15642 | 99.2% | |
| 1 | 120 | 0.8% |
yr_built
Numeric
| Distinct count | 116 |
|---|---|
| Unique (%) | 0.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1971.111217 |
|---|---|
| Minimum | 1900 |
| Maximum | 2015 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1900 |
|---|---|
| 5-th percentile | 1915 |
| Q1 | 1952 |
| Median | 1975 |
| Q3 | 1997 |
| 95-th percentile | 2011 |
| Maximum | 2015 |
| Range | 115 |
| Interquartile range | 45 |
Descriptive statistics
| Standard deviation | 29.33682327 |
|---|---|
| Coef of variation | 0.0148833932 |
| Kurtosis | -0.6465086991 |
| Mean | 1971.111217 |
| MAD | 24.52195997 |
| Skewness | -0.479157912 |
| Sum | 31068655 |
| Variance | 860.6491997 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[1900. 1900.5 1904.5 1909.5 1910.5 ... 2009.5 2012.5 2013.5 2014.5 2015. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 2014 | 400 | 2.5% | |
| 2006 | 335 | 2.1% | |
| 2005 | 327 | 2.1% | |
| 2007 | 308 | 2.0% | |
| 2004 | 304 | 1.9% | |
| 2003 | 302 | 1.9% | |
| 1977 | 301 | 1.9% | |
| 1978 | 289 | 1.8% | |
| 1968 | 286 | 1.8% | |
| 2008 | 264 | 1.7% | |
| Other values (106) | 12646 | 80.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1900 | 59 | 0.4% | |
| 1901 | 22 | 0.1% | |
| 1902 | 18 | 0.1% | |
| 1903 | 28 | 0.2% | |
| 1904 | 38 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2015 | 25 | 0.2% | |
| 2014 | 400 | 2.5% | |
| 2013 | 153 | 1.0% | |
| 2012 | 121 | 0.8% | |
| 2011 | 94 | 0.6% |
yr_renovated
Numeric
| Distinct count | 70 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 82.44023601 |
|---|---|
| Minimum | 0 |
| Maximum | 2015 |
| Zeros (%) | 95.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 2015 |
| Range | 2015 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 397.2126256 |
|---|---|
| Coef of variation | 4.818188846 |
| Kurtosis | 19.26758165 |
| Mean | 82.44023601 |
| MAD | 158.070601 |
| Skewness | 4.611241041 |
| Sum | 1299423 |
| Variance | 157777.8699 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 0. 967. 1937. 1954.5 1967.5 1982.5 1999.5 2010.5 2012.5 2015. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 15111 | 95.9% | |
| 2014 | 64 | 0.4% | |
| 2013 | 29 | 0.2% | |
| 2005 | 27 | 0.2% | |
| 2000 | 25 | 0.2% | |
| 2007 | 24 | 0.2% | |
| 2003 | 24 | 0.2% | |
| 1990 | 22 | 0.1% | |
| 2009 | 19 | 0.1% | |
| 2004 | 18 | 0.1% | |
| Other values (60) | 399 | 2.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 15111 | 95.9% | |
| 1934 | 1 | < 0.1% | |
| 1940 | 2 | < 0.1% | |
| 1944 | 1 | < 0.1% | |
| 1945 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2015 | 13 | 0.1% | |
| 2014 | 64 | 0.4% | |
| 2013 | 29 | 0.2% | |
| 2012 | 7 | < 0.1% | |
| 2011 | 7 | < 0.1% |
zipcode
Numeric
| Distinct count | 70 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 98077.55824 |
|---|---|
| Minimum | 98001 |
| Maximum | 98199 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 98001 |
|---|---|
| 5-th percentile | 98004 |
| Q1 | 98033 |
| Median | 98065 |
| Q3 | 98117 |
| 95-th percentile | 98177 |
| Maximum | 98199 |
| Range | 198 |
| Interquartile range | 84 |
Descriptive statistics
| Standard deviation | 53.41490569 |
|---|---|
| Coef of variation | 0.0005446190408 |
| Kurtosis | -0.8483166889 |
| Mean | 98077.55824 |
| MAD | 46.61151031 |
| Skewness | 0.4133118275 |
| Sum | 1545898473 |
| Variance | 2853.15215 |
| Memory size | 123.2 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[98001. 98001.5 98002.5 98004.5 98005.5 ... 98151.5 98183. 98193. 98198.5 98199. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 98038 | 437 | 2.8% | |
| 98103 | 425 | 2.7% | |
| 98052 | 416 | 2.6% | |
| 98042 | 408 | 2.6% | |
| 98115 | 407 | 2.6% | |
| 98117 | 403 | 2.6% | |
| 98034 | 396 | 2.5% | |
| 98118 | 368 | 2.3% | |
| 98023 | 368 | 2.3% | |
| 98006 | 361 | 2.3% | |
| Other values (60) | 11773 | 74.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 98001 | 255 | 1.6% | |
| 98002 | 149 | 0.9% | |
| 98003 | 217 | 1.4% | |
| 98004 | 231 | 1.5% | |
| 98005 | 129 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 98199 | 221 | 1.4% | |
| 98198 | 204 | 1.3% | |
| 98188 | 97 | 0.6% | |
| 98178 | 189 | 1.2% | |
| 98177 | 187 | 1.2% |
First rows
| bathrooms | bedrooms | condition | date | df_index | floors | grade | id | lat | long | price | sqft_above | sqft_basement | sqft_living | sqft_living15 | sqft_lot | sqft_lot15 | view | waterfront | yr_built | yr_renovated | zipcode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2.25 | 3 | 3 | 12/9/2014 | 1 | 2.0 | 7 | 6414100192 | 47.7210 | -122.319 | 538000.0 | 2170 | 400.0 | 2570 | 1690 | 7242 | 7639 | 0.0 | 0.0 | 1951 | 1991.0 | 98125 |
| 1 | 3.00 | 4 | 5 | 12/9/2014 | 3 | 1.0 | 7 | 2487200875 | 47.5208 | -122.393 | 604000.0 | 1050 | 910.0 | 1960 | 1360 | 5000 | 5000 | 0.0 | 0.0 | 1965 | 0.0 | 98136 |
| 2 | 2.00 | 3 | 3 | 2/18/2015 | 4 | 1.0 | 8 | 1954400510 | 47.6168 | -122.045 | 510000.0 | 1680 | 0.0 | 1680 | 1800 | 8080 | 7503 | 0.0 | 0.0 | 1987 | 0.0 | 98074 |
| 3 | 4.50 | 4 | 3 | 5/12/2014 | 5 | 1.0 | 11 | 7237550310 | 47.6561 | -122.005 | 1230000.0 | 3890 | 1530.0 | 5420 | 4760 | 101930 | 101930 | 0.0 | 0.0 | 2001 | 0.0 | 98053 |
| 4 | 2.25 | 3 | 3 | 6/27/2014 | 6 | 2.0 | 7 | 1321400060 | 47.3097 | -122.327 | 257500.0 | 1715 | ? | 1715 | 2238 | 6819 | 6819 | 0.0 | 0.0 | 1995 | 0.0 | 98003 |
| 5 | 1.00 | 3 | 3 | 4/15/2015 | 8 | 1.0 | 7 | 2414600126 | 47.5123 | -122.337 | 229500.0 | 1050 | 730.0 | 1780 | 1780 | 7470 | 8113 | 0.0 | 0.0 | 1960 | 0.0 | 98146 |
| 6 | 2.50 | 3 | 3 | 3/12/2015 | 9 | 2.0 | 7 | 3793500160 | 47.3684 | -122.031 | 323000.0 | 1890 | 0.0 | 1890 | 2390 | 6560 | 7570 | 0.0 | 0.0 | 2003 | 0.0 | 98038 |
| 7 | 1.00 | 2 | 4 | 5/27/2014 | 11 | 1.0 | 7 | 9212900260 | 47.6900 | -122.292 | 468000.0 | 860 | 300.0 | 1160 | 1330 | 6000 | 6000 | 0.0 | 0.0 | 1942 | 0.0 | 98115 |
| 8 | 1.75 | 3 | 4 | 10/7/2014 | 13 | 1.0 | 7 | 6054650070 | 47.6127 | -122.045 | 400000.0 | 1370 | 0.0 | 1370 | 1370 | 9680 | 10208 | 0.0 | 0.0 | 1977 | 0.0 | 98074 |
| 9 | 2.00 | 5 | 3 | 3/12/2015 | 14 | 1.5 | 7 | 1175000570 | 47.6700 | -122.394 | 530000.0 | 1810 | 0.0 | 1810 | 1360 | 4850 | 4850 | 0.0 | 0.0 | 1900 | 0.0 | 98107 |
Last rows
| bathrooms | bedrooms | condition | date | df_index | floors | grade | id | lat | long | price | sqft_above | sqft_basement | sqft_living | sqft_living15 | sqft_lot | sqft_lot15 | view | waterfront | yr_built | yr_renovated | zipcode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15752 | 2.75 | 5 | 3 | 8/13/2014 | 21580 | 2.0 | 9 | 7502800100 | 47.4822 | -122.131 | 679950.0 | 3600 | 0.0 | 3600 | 3550 | 9437 | 9421 | 0.0 | 0.0 | 2014 | 0.0 | 98059 |
| 15753 | 3.75 | 5 | 3 | 10/15/2014 | 21584 | 2.0 | 11 | 249000205 | 47.6321 | -122.200 | 1540000.0 | 4470 | 0.0 | 4470 | 2780 | 8088 | 8964 | 0.0 | 0.0 | 2008 | 0.0 | 98004 |
| 15754 | 2.50 | 3 | 3 | 4/7/2015 | 21585 | 3.0 | 8 | 5100403806 | 47.6963 | -122.318 | 467000.0 | 1425 | 0.0 | 1425 | 1285 | 1179 | 1253 | 0.0 | 0.0 | 2008 | 0.0 | 98125 |
| 15755 | 2.00 | 3 | 3 | 1/26/2015 | 21588 | 3.0 | 8 | 9834201367 | 47.5699 | -122.288 | 429000.0 | 1490 | 0.0 | 1490 | 1400 | 1126 | 1230 | 0.0 | 0.0 | 2014 | 0.0 | 98144 |
| 15756 | 3.50 | 4 | 3 | 3/26/2015 | 21590 | 2.0 | 9 | 7936000429 | 47.5537 | -122.398 | 1010000.0 | 2600 | 910.0 | 3510 | 2050 | 7200 | 6200 | 0.0 | 0.0 | 2009 | 0.0 | 98136 |
| 15757 | 2.50 | 3 | 3 | 2/19/2015 | 21591 | 2.0 | 8 | 2997800021 | 47.5773 | -122.409 | 475000.0 | 1180 | 130.0 | 1310 | 1330 | 1294 | 1265 | 0.0 | 0.0 | 2008 | 0.0 | 98116 |
| 15758 | 2.50 | 3 | 3 | 5/21/2014 | 21592 | 3.0 | 8 | 263000018 | 47.6993 | -122.346 | 360000.0 | 1530 | 0.0 | 1530 | 1530 | 1131 | 1509 | 0.0 | 0.0 | 2009 | 0.0 | 98103 |
| 15759 | 2.50 | 4 | 3 | 2/23/2015 | 21593 | 2.0 | 8 | 6600060120 | 47.5107 | -122.362 | 400000.0 | 2310 | 0.0 | 2310 | 1830 | 5813 | 7200 | 0.0 | 0.0 | 2014 | 0.0 | 98146 |
| 15760 | 0.75 | 2 | 3 | 6/23/2014 | 21594 | 2.0 | 7 | 1523300141 | 47.5944 | -122.299 | 402101.0 | 1020 | 0.0 | 1020 | 1020 | 1350 | 2007 | 0.0 | 0.0 | 2009 | 0.0 | 98144 |
| 15761 | 0.75 | 2 | 3 | 10/15/2014 | 21596 | 2.0 | 7 | 1523300157 | 47.5941 | -122.299 | 325000.0 | 1020 | 0.0 | 1020 | 1020 | 1076 | 1357 | 0.0 | 0.0 | 2008 | 0.0 | 98144 |